Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
OBJ | VARCHAR2(20) | No | null | 1 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 2 | null | NO | NO | NO |
OBJ_TYPE | VARCHAR2(100) | Yes | null | 3 | null | NO | NO | NO |
TITLE | VARCHAR2(100) | Yes | null | 4 | null | NO | NO | NO |
LEAD | VARCHAR2(400) | Yes | null | 5 | null | NO | NO | NO |
INITIAL_ALLEGATION | VARCHAR2(4000) | Yes | null | 6 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 7 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 8 | null | NO | NO | NO |
LEAD_OBJ | VARCHAR2(20) | No | null | 9 | null | NO | NO | NO |
ASSOC_ID | VARCHAR2(100) | Yes | null | 10 | null | NO | NO | NO |
ASSOC_OBJ_TYPE | VARCHAR2(100) | Yes | null | 11 | null | NO | NO | NO |
ASSOC_DISPOSITION | VARCHAR2(4000) | Yes | null | 12 | null | NO | NO | NO |
ASSOC_LEAD | VARCHAR2(400) | Yes | null | 13 | null | NO | NO | NO |
ASSOC_LEAD_OBJ | VARCHAR2(20) | Yes | null | 14 | null | NO | NO | NO |
ASSOC_STATUS | VARCHAR2(100) | Yes | null | 15 | null | NO | NO | NO |
ASSOC_SPPT_PERS | VARCHAR2(400) | Yes | null | 16 | null | NO | NO | NO |
ASSOC_SPPT_PERS_OBJ | VARCHAR2(20) | Yes | null | 17 | null | NO | NO | NO |
ASSOC_CREATED_ON | DATE | Yes | null | 18 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 23-OCT-24 |
LAST_DDL_TIME | 21-NOV-24 |
OWNER | QART |
VIEW_NAME | V_INTAKE_ASSOC_FILES |
TEXT_LENGTH | 2817 |
TEXT | WITH z as (select i.obj, i.ID, iot.display obj_type, i.title, i.lead_personnel, i.initial_allegation, i.status, i.created_date, lp.sh_obj lead_obj, ia.ID assoc_id, ia.OBJ_TYPE assoc_obj, ia.DISPOSITION assoc_disposition, ia.LEAD assoc_lead, ia.lead_obj assoc_lead_obj, ia.STATUS assoc_status, ia.SUPPORT_PERSONNEL assoc_sppt_pers, ia.support_pers_obj assoc_sppt_pers_obj, ia.CREATED_ON assoc_created_on from V_SIIC_INTAKE i inner join mv_acm_obj io on i.obj = io.sid inner join mv_acm_obj_type iot on io.obj_type = iot.sid inner join V_CURR_OBJ_LEAD_PERS lp on i.obj = lp.obj left outer join mv_acm_association a on i.obj = a.from_obj and a.FILE_CREATED_BY_FROM_OBJ = 'Y' inner join v_all_files_intake_assoc ia on a.to_obj = ia.obj) select obj, ID, OBJ_TYPE, title, lead, initial_allegation, status, created_date, lead_obj, assoc_id, assoc_obj, assoc_disposition, assoc_lead, assoc_lead_obj, assoc_status, assoc_sppt_pers, assoc_sppt_pers_obj, assoc_created_on from ( select (case when seqnum_id = 1 then ID else '' end) as id, (case when seqnum_obj_type = 1 then obj_type else '' end) as obj_type, (case when seqnum_title = 1 then title else '' end) as title, (case when seqnum_lead = 1 then lead_personnel else '' end) as lead, (case when seqnum_init_allegation = 1 then initial_allegation else '' end) as initial_allegation, (case when seqnum_created_date = 1 then created_date else null end) as created_date, (case when seqnum_status = 1 then status else '' end) as status, obj, lead_obj, assoc_id, assoc_obj, assoc_disposition, assoc_lead, assoc_lead_obj, assoc_status, assoc_sppt_pers, assoc_sppt_pers_obj, assoc_created_on from (select z.*, row_number() over (partition by ID order by obj_type, title, lead_personnel, initial_allegation, created_date, status) as seqnum_id, row_number() over (partition by ID, obj_type order by title, lead_personnel, initial_allegation, created_date, status) as seqnum_obj_type, row_number() over (partition by ID, obj_type, title order by lead_personnel, initial_allegation, created_date, status) as seqnum_title, row_number() over (partition by ID, obj_type, title, lead_personnel order by initial_allegation, created_date, status) as seqnum_lead, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation order by created_date, status) as seqnum_init_allegation, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation, created_date order by status) as seqnum_created_date, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation, created_date, status order by obj) as seqnum_status from z ) ) order by obj |
TEXT_VC | WITH z as (select i.obj, i.ID, iot.display obj_type, i.title, i.lead_personnel, i.initial_allegation, i.status, i.created_date, lp.sh_obj lead_obj, ia.ID assoc_id, ia.OBJ_TYPE assoc_obj, ia.DISPOSITION assoc_disposition, ia.LEAD assoc_lead, ia.lead_obj assoc_lead_obj, ia.STATUS assoc_status, ia.SUPPORT_PERSONNEL assoc_sppt_pers, ia.support_pers_obj assoc_sppt_pers_obj, ia.CREATED_ON assoc_created_on from V_SIIC_INTAKE i inner join mv_acm_obj io on i.obj = io.sid inner join mv_acm_obj_type iot on io.obj_type = iot.sid inner join V_CURR_OBJ_LEAD_PERS lp on i.obj = lp.obj left outer join mv_acm_association a on i.obj = a.from_obj and a.FILE_CREATED_BY_FROM_OBJ = 'Y' inner join v_all_files_intake_assoc ia on a.to_obj = ia.obj) select obj, ID, OBJ_TYPE, title, lead, initial_allegation, status, created_date, lead_obj, assoc_id, assoc_obj, assoc_disposition, assoc_lead, assoc_lead_obj, assoc_status, assoc_sppt_pers, assoc_sppt_pers_obj, assoc_created_on from ( select (case when seqnum_id = 1 then ID else '' end) as id, (case when seqnum_obj_type = 1 then obj_type else '' end) as obj_type, (case when seqnum_title = 1 then title else '' end) as title, (case when seqnum_lead = 1 then lead_personnel else '' end) as lead, (case when seqnum_init_allegation = 1 then initial_allegation else '' end) as initial_allegation, (case when seqnum_created_date = 1 then created_date else null end) as created_date, (case when seqnum_status = 1 then status else '' end) as status, obj, lead_obj, assoc_id, assoc_obj, assoc_disposition, assoc_lead, assoc_lead_obj, assoc_status, assoc_sppt_pers, assoc_sppt_pers_obj, assoc_created_on from (select z.*, row_number() over (partition by ID order by obj_type, title, lead_personnel, initial_allegation, created_date, status) as seqnum_id, row_number() over (partition by ID, obj_type order by title, lead_personnel, initial_allegation, created_date, status) as seqnum_obj_type, row_number() over (partition by ID, obj_type, title order by lead_personnel, initial_allegation, created_date, status) as seqnum_title, row_number() over (partition by ID, obj_type, title, lead_personnel order by initial_allegation, created_date, status) as seqnum_lead, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation order by created_date, status) as seqnum_init_allegation, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation, created_date order by status) as seqnum_created_date, row_number() over (partition by ID, obj_type, title, lead_personnel, initial_allegation, created_date, status order by obj) as seqnum_status from z ) ) order by obj |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|